INSERTING AND DELETING CELLS

When you tell Excel to insert or delete a cell within a range of data, Excel needs to know how to move the data that is in adjacent cells. You specify your preferences in the Insert or Delete dialog box.

To Insert a Cell

• Click the destination for the new, blank cell.
• Choose Insert Cells from the Insert dropdown menu.

OR
Right-click the cell and choose Insert from the shortcut menu.

• In the Insert dialog box , select either Shift Cells Right or Shift Cells Down.
• The new cell appears.

To Delete a Cell

• Click the cell you want to delete.
• Click on Delete button from Cells group of Home ribbon and choose Delete cell from dropdown menu.

OR
Right-click the cell and choose Delete from the shortcut menu.

• In the Delete dialog box, select either Shift Cells Left or Shift Cells Up.
• To delete an entire row or column, select at least one cell in the row or column, choose Delete cell from dropdown list of delete button from cells group of Home ribbon, and in the Delete dialog box, choose either Entire Row or Entire Column.